
-----------------------------------------------------------------------------
-- DDL for Table'common.dbo.t_ReleaseObjects'
-----------------------------------------------------------------------------
print 'Creating Table common.dbo.t_ReleaseObjects'
go 

use common
go 

setuser 'dbo'
go 
drop table t_ReleaseObjects
go
create table t_ReleaseObjects (
	CuId    			numeric(6,0)                     IDENTITY NOT NULL,
	Parent                          int                             NOT NULL,
	Scope                           varchar(2)                      NULL,
	ArtfactId                       int				NULL,
	Status                          char(1)                         NULL,
	ReleaseName      		varchar(30)			NULL,
	DBName           		varchar(30)			NULL,
	ObjName          		varchar(1000)			NULL,
	ObjType          		varchar(50)			NULL,
	OrderId          		int				NULL,
	UserUpdated      		varchar(50)			NULL,
	DateUpdated      		varchar(20)			NULL,
	Repopath         		varchar(1000)			NULL,
	ActualUserUpdated		varchar(50)			NULL,
	ContactPerson    		varchar(50)			NULL,
	Valid            		char(1)				NULL,
	UserValidated    		varchar(50)			NULL,
	DateValidated    		varchar(10)			NULL,
	CR_Reason        		varchar(250)			NULL 
)
go


Grant Select on dbo.t_ReleaseObjects to public 
go

setuser
go 

